﻿-- =============================================
-- Datos de ejemplo
-- =============================================
DECLARE @xID INT

EXEC esf_sso.P_InsertBasicReference @xID OUT, 3000, 'Colmedica', 'E:\Proyectos\PYS\Muestras Scanner\Colmedica', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 3000, 'Ecoopsos', 'E:\Proyectos\PYS\Muestras Scanner\Ecoopsos', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 3000, 'Famisanar', 'E:\Proyectos\PYS\Muestras Scanner\Famisanar', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 3000, 'CSJ', 'E:\Proyectos\PYS\Muestras Scanner\Libros_Concejo', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 3000, 'Salud Total', 'E:\Proyectos\PYS\Muestras Scanner\Salud Total', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 3000, 'Salud Vida', 'E:\Proyectos\PYS\Muestras Scanner\Salud Vida', NULL, NULL, NULL, NULL, 1, 'root'

-- =============================================
-- Tipos de Archivo
-- =============================================
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.pdf', 'PDF, Portable Document Format', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.jpg', 'JPG, Joint Photographic Experts Group', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.jpeg', 'JPG, Joint Photographic Experts Group ', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.bmp', 'BMP, Bitmap Image File', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.gif', 'GIF, Graphics Interchange Format', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.png', 'JPG, Portable Network Graphics', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.doc', 'DOC, Microsoft Document Office 2003', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.docx', 'DOCX, Microsoft Document Office 2007/10', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.xls', 'XLS, Microsoft Excel 2003', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.xlsx', 'XLSX, Microsoft Excel 2007/10', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.ppt', 'PPT, Microsoft Power Point 2003', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.pptx', 'PPTX, Microsoft Power Point 2007/10', NULL, NULL, NULL, NULL, 1, 'root'
EXEC esf_sso.P_InsertBasicReference @xID OUT, 12, '.tif', 'TIF, Tagged Image File Format', NULL, NULL, NULL, NULL, 1, 'root'